Ledger Activity Details Report

The Ledger Activity Details report allows users to monitor the activity within and between the A/R, City, Deposit and Guest ledgers. This includes the beginning balance, ending balance, details, and totals by item broken down into groupings by posting type for each ledger.

Perform the following steps to generate the report:

Navigate to Reports ➜ Dynamic Reports ➜ Accounting ➜ Ledger Activity Details report.

Refer to the following table and fill in the fields.

Field	Description
Report Name	Ledger Activity Details.
Property	This is a mandatory multi-select drop-down list that allows users to select the properties for report generation. The current property is selected by default.
Start Date	The start date for report generation. This is a mandatory field that displays the date that is a day prior to the current property date by default. Users can select past dates. Future dates cannot be selected.
End Date	The end date for report generation. This is a mandatory field that displays the date that is a day prior to the current property date by default. Users can select past dates. Future dates cannot be selected.
Ledger	This is a multi-select drop-down list that displays the following options: A/R City Deposit Guest By default, no option is selected. Users must select the ledgers to be included in the generated report. When no option is selected, all ledgers are included in the generated report.
Transaction Type	This is a multi-select drop-down list that displays the following options: Payments Revenue Transfers By default, no option is selected. Users must select the transaction types to be included in the generated report. When no option is selected, all transaction types are included in the generated report.
Transaction Items	This is a multi-select drop-down list that displays the transaction items available at the property. By default, no option is selected. Users must select the transaction items to be included in the generated report. When no option is selected, all transaction items are included in the generated report.
Inventory Items	This is a multi-select drop-down list that displays the inventory items available at the property. By default, no option is selected. Users must select the inventory items to be included in the generated report. When no option is selected, all inventory items are included in the generated report.
Payment Methods	This is a multi-select drop-down list that displays the payment methods available at the property. By default, no option is selected. Users must select the payment methods to be included in the generated report. When no option is selected, all payment methods are included in the generated report.
GL Code	This is a multi-select drop-down list that displays the GL codes configured by the property. By default, no option is selected. Users must select the GL codes to be included in the generated report. When no option is selected, all GL codes are included in the generated report.

Click Run to generate the report.

Click Save to save the report under User Favorites section.

Sample Report

Report Fields

This report displays the following fields:

Field	Description
Ledger	The ledger name is displayed with an accordion. When the accordion is collapsed, only the beginning and ending balance of the ledger is displayed. When the accordion is expanded, values are displayed for the remaining columns. This column can be filtered.
Transaction Type	The transaction type is displayed with an accordion. When the accordion is collapsed, only the total amount, beginning and ending balance of the transaction type is displayed. When the accordion is expanded, values are displayed for the remaining columns. This column can be filtered.
Transaction Item	The transaction item posted to the ledger is displayed with an accordion. When the accordion is collapsed, only the transaction item code, total amount, beginning and ending balance are displayed. When the accordion is expanded, values are displayed for the remaining columns.
Transaction Code	The transaction item code.
GL Code	The GL code of the item. This column can be filtered.
Outlet	The outlet through which the item was posted. This column can be filtered.
User	The user who performed the transaction.
Posting Date	The date when the item was posted.
Posting Time	The time when the item was posted.
Confirmation	The confirmation ID of the reservation in which the item was posted. This column can be filtered and sorted.
Guest Name	The guest name associated with the reservation.
Room Number	The room number assigned to the reservation.
Amount	The amount posted for the item.
Beginning	The beginning balance of the ledger.
Ending	The ending balance of the ledger.